package meconsea.life.clan.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;

import meconsea.life.sys.entity.AbsEntity;

import org.hibernate.annotations.Type;

@Entity
@Table(name="CLAN_INFO")
@NamedQueries({
	@NamedQuery(name =ClanInfo.CLAN_INFO_FIND_CD ,query="SELECT o FROM ClanInfo o where o.clanName like :clanName"),
	@NamedQuery(name = ClanInfo.CLAN_INFO_FIND_CK,query = "SELECT O FROM ClanInfo O where O.clanDiscription like :clanDiscription"),
	@NamedQuery(name = ClanInfo.CLAN_INFO_FIND_CN,query = "SELECT o FROM ClanInfo o where o.clanKeywords like :clanKeywords"),
	@NamedQuery(name = ClanInfo.CLAN_INFO_FIND_ALL,query = "SELECT O FROM ClanInfo O  order by O.createdAt"),
	@NamedQuery(name = ClanInfo.CLAN_INFO_FIND_COMMEND,query = "SELECT o FROM ClanInfo o where o.isCommend=o.isCommend")
})
public class ClanInfo extends AbsEntity {
	
	public final static String CLAN_INFO_FIND_CN = "clan_info_find_cn";
	public final static String CLAN_INFO_FIND_CD = "clan_info_find_cd";
	public final static String CLAN_INFO_FIND_CK = "clan_info_find_ck";
	public final static String CLAN_INFO_FIND_ALL = "clan_info_find_all";
	public final static String CLAN_INFO_FIND_COMMEND = "clan_info_find_commend";
	
	@Column(name="clanName",length=1024)
	private String clanName;
	
	@Column(name="clanDiscription")
	@Type(type="text")
	private String clanDiscription;
	
	@Column(name="clanLogo",length=1024)
	private String clanLogo;
	
	@Column(name="browsePopedom")
	@Type(type="integer")
	private String browsePopedom;
	
	@Column(name="clanType")
	private String clanType;
	
	@Column(name="clanBoard")
	@Type(type="text")
	private String clanBoard;
	
	@Column(name="clanKeywords")
	private String clanKeywords;
	
	@Column(name="clanArea")
	private String clanArea;
	
	@Column(name="isCommend")
	@Type(type="integer")
	private String isCommend;

	public String getIsCommend() {
		return isCommend;
	}

	public void setIsCommend(String isCommend) {
		this.isCommend = isCommend;
	}

	public String getClanName() {
		return clanName;
	}

	public void setClanName(String clanName) {
		this.clanName = clanName;
	}

	public String getClanDiscription() {
		return clanDiscription;
	}

	public void setClanDiscription(String clanDiscription) {
		this.clanDiscription = clanDiscription;
	}

	public String getClanLogo() {
		return clanLogo;
	}

	public void setClanLogo(String clanLogo) {
		this.clanLogo = clanLogo;
	}

	public String getBrowsePopedom() {
		return browsePopedom;
	}

	public void setBrowsePopedom(String browsePopedom) {
		this.browsePopedom = browsePopedom;
	}

	public String getClanType() {
		return clanType;
	}

	public void setClanType(String clanType) {
		this.clanType = clanType;
	}

	public String getClanBoard() {
		return clanBoard;
	}

	public void setClanBoard(String clanBoard) {
		this.clanBoard = clanBoard;
	}

	public String getClanKeywords() {
		return clanKeywords;
	}

	public void setClanKeywords(String clanKeywords) {
		this.clanKeywords = clanKeywords;
	}

	public String getClanArea() {
		return clanArea;
	}

	public void setClanArea(String clanArea) {
		this.clanArea = clanArea;
	}
	
}
